UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsmO1j6Sz1gzIT7fZhzRm43Y5L11oxRFmVreElRXDIM='
WHERE
key_id = '7d9003979f475814a8a15bc3efe499d29371a672225f2e7286cc583532a4e36a'
AND (
token = 'hsmO1j6Sz1gzIT7fZhzRm43Y5L11oxRFmVreElRXDIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)