UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lBzczWmKI4zQNutUEeRToHg7NFFPJprRPNHqIEZGFMU='
WHERE
key_id = '40dc65fbaf331822c79bd49b3910ccf929ae90074b319c4bb6cf0a912547ac69'
AND (
token = 'lBzczWmKI4zQNutUEeRToHg7NFFPJprRPNHqIEZGFMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)