UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KxpPIEPz6NLlFWqW0pCOnpLdNrhzKbD9HgFlmLNeaZQ='
WHERE
key_id = '9d2bc4f9b12b656d3774940f299ab4300fd0a8cddfb138f6115c840d36ca0488'
AND (
token = 'KxpPIEPz6NLlFWqW0pCOnpLdNrhzKbD9HgFlmLNeaZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)