UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Ff8CY5WS4VNVBrx3JNiyUhIjflACFScf4r+wiAjKg8='
WHERE
key_id = '82e03879912cb385cc3eea00d7b2baf197b26b56334a7ad1aa6926f475e1a358'
AND (
token = '3Ff8CY5WS4VNVBrx3JNiyUhIjflACFScf4r+wiAjKg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)