UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/6hfEjQRI2xWBut4QTOi2XpMOPaEN0tDX/NHlskfklw='
WHERE
key_id = '11f7404fdc741d5b1c0b950fc1b89ea082887be46489c8989750dc45f05c89b9'
AND (
token = '/6hfEjQRI2xWBut4QTOi2XpMOPaEN0tDX/NHlskfklw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)