UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPNinvsCTfCOU3muaG6mihT5YMhM0t81xMCHrhL1xj8='
WHERE
key_id = '0816a953cd9c7701b1c5c0cf28c0d7564203da749d6b3caadd4665682a9732ef'
AND (
token = 'qPNinvsCTfCOU3muaG6mihT5YMhM0t81xMCHrhL1xj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)