UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJcD7Zf56H8iIMMB6zbeUnRotbKkJKCzHLTGUYyhJYo='
WHERE
key_id = 'b85f96fcb23059193bff35f73a421a7bc06f0272d3b7f9ce20e5c540eebc2198'
AND (
token = 'gJcD7Zf56H8iIMMB6zbeUnRotbKkJKCzHLTGUYyhJYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)