UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xnisZYRw6Op/OduDtwK8muVo52GupCIl9dm5WbnAnr4='
WHERE
key_id = '824b1b85cd1b173af3deccb8ca044b722976d349cf5e8709f9246cf7edeb11bc'
AND (
token = 'xnisZYRw6Op/OduDtwK8muVo52GupCIl9dm5WbnAnr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)