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