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