UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPbUfCrXm4zuZO+C477bofzAsKzYPy3fHB+UKNAIZzU='
WHERE
key_id = 'b07e2b45901aa46e9bd4e5c0192155d3b551a0554d80bd3fa4d936b8254d7bb3'
AND (
token = 'HPbUfCrXm4zuZO+C477bofzAsKzYPy3fHB+UKNAIZzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)