UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rm63dJcX8h2E/NjeXYYCKkFubLOubGvu+1Egc970t6k='
WHERE
key_id = '2d978e3ce245b5078a1abfa7afde9bb6396b7e5be941e383da78b1a4d068d88b'
AND (
token = 'rm63dJcX8h2E/NjeXYYCKkFubLOubGvu+1Egc970t6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)