UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXp51CfyREtnRHC6sklCg/3ILyynBQyTdw5u4GYkX34='
WHERE
key_id = 'b9fe217b7dc76dbbe5d6725a56a7a35f7c9e33624368e46393a4b5f4b3b74172'
AND (
token = 'EXp51CfyREtnRHC6sklCg/3ILyynBQyTdw5u4GYkX34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)