UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4v9be+tV5F5MVrRxccVWov8dRzeX9h8TjgweE+u70k='
WHERE
key_id = '8594cd4f4a835bf16b1b933fd8f1c032c7c4b2dc783c9566072ba1057969ede1'
AND (
token = 'N4v9be+tV5F5MVrRxccVWov8dRzeX9h8TjgweE+u70k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)