UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vt6dVqtpBb+3/Mbx0daB41dpuFX9ZkJGpTVEgCHICo8='
WHERE
key_id = '789d1e86a54920519ba1788f3649434b882c9cff4564a716b9ae599393d5d9ab'
AND (
token = 'Vt6dVqtpBb+3/Mbx0daB41dpuFX9ZkJGpTVEgCHICo8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)