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