UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1bHetz6Zm9G37wLI7irXeBWG60V8yL5v169z9CpuDk='
WHERE
key_id = 'c8ff20b159d68d644c60db0988ca5b7c885d4bc973ffc410fd3f47596ed586d7'
AND (
token = 'C1bHetz6Zm9G37wLI7irXeBWG60V8yL5v169z9CpuDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)