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