UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bE9923gGRAKnCg8v21F7ZaHtaNKRolnlaW6BYsPHG8c='
WHERE
key_id = '3929f4bb50c00e1eda14f2b818a03c0b334c1930a4c4a9f85ab2c629275a981e'
AND (
token = 'bE9923gGRAKnCg8v21F7ZaHtaNKRolnlaW6BYsPHG8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)