UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UR3AQIL4YhrAjIKYczLagtoEwbmY1N9OboX9qhOoWI0='
WHERE
key_id = '1c48ffe69c1b11af5dab5a75f476c98b0bc87d37bd44258bcbbd0c4ba85d9b8e'
AND (
token = 'UR3AQIL4YhrAjIKYczLagtoEwbmY1N9OboX9qhOoWI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)