UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wqQTHPNKrlXg7OGvPajCi2y+wYYBbe+yO1RI8Ab/eK4='
WHERE
key_id = 'bdf080d5d3b6ff7c44fd5fd0f2bf8f4d5b01b5d3246ae95e6eded1a52c9ced02'
AND (
token = 'wqQTHPNKrlXg7OGvPajCi2y+wYYBbe+yO1RI8Ab/eK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)