UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZoeXF81DrO0rHLc1Nf4kXFHbfxBkQ3HErDdzmgXKp0='
WHERE
key_id = '30560760e0cf5ea033e2b242d32dd2f83ab0a8f4d3bd718ca61d701d84e5b5fe'
AND (
token = 'zZoeXF81DrO0rHLc1Nf4kXFHbfxBkQ3HErDdzmgXKp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)