UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aGY653DLFyLiDogKtTMkqVIm0WXcImkTDdoSY9sX4x8='
WHERE
key_id = '8c4ed260a6333d1b0f4df609900a26c99123aab8815f01eeaca8f0e2831e999c'
AND (
token = 'aGY653DLFyLiDogKtTMkqVIm0WXcImkTDdoSY9sX4x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)