UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJjelGyi1gmg4EQB69kOjbo8KnN3DpbQ/wgTifwpKhI='
WHERE
key_id = 'c618855545eacf26a34ff6462c46961c9a8385a5077971fb8df840e129301967'
AND (
token = 'zJjelGyi1gmg4EQB69kOjbo8KnN3DpbQ/wgTifwpKhI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)