UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hxvy7WrcON0d0xcPu63Rs/ypA9GUGOar6bwmWGKzFfA='
WHERE
key_id = '100339a48cb5c6fab2460eb0a820a57a04ad96e6aa06f6d92f805f8827d5555a'
AND (
token = 'Hxvy7WrcON0d0xcPu63Rs/ypA9GUGOar6bwmWGKzFfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)