UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMJmIxfJ7VEcntxck2ZeNOk23iyrJh9FcM3rW4gXRfs='
WHERE
key_id = '404b889ef9bb50c7da0d851aab759f7ab2a517bac606c48f7eca137ea3f0142a'
AND (
token = 'BMJmIxfJ7VEcntxck2ZeNOk23iyrJh9FcM3rW4gXRfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)