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