UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdxAhHLsdSW38bZgnTHw036NzzyJIH6v7O3aeg2FeHk='
WHERE
key_id = '1356772c21987e5644041162dde2754fcd2f81cc84315435aafb2b2496d3032a'
AND (
token = 'XdxAhHLsdSW38bZgnTHw036NzzyJIH6v7O3aeg2FeHk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)