UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Q8Hd4P0JAHlf7EIFQh2OepqmcklDYgj0f7fKRFBhx4='
WHERE
key_id = 'f759b3bca74baa9b9d6ab63c5bbe5778d111b0eab15060d907971d6caf8cee4d'
AND (
token = '6Q8Hd4P0JAHlf7EIFQh2OepqmcklDYgj0f7fKRFBhx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)