UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGgzjA2DonUMr428ABE2KEJ6+Xi6DnIpiCXxjhCzzno='
WHERE
key_id = '2a7f7be1510702a0c9303d1a2acdae78feabc4a0c5c912b27009d680837fc086'
AND (
token = 'vGgzjA2DonUMr428ABE2KEJ6+Xi6DnIpiCXxjhCzzno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)