UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKkN2t5U0oarnvV8Q4ys9ObQtse+jZuYWsggN+Igh+4='
WHERE
key_id = 'c7ac66d149502d25fad464cd482904a57cf32c7c9b8e9291dbeb4303d652422c'
AND (
token = 'RKkN2t5U0oarnvV8Q4ys9ObQtse+jZuYWsggN+Igh+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)