UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xw6v+vSvpOQdZgbBukfhmVWHUWb1ie9mHdv1w1RoJYw='
WHERE
key_id = '4c99d5350c34b834c1774d0531a2bc35a5a7040f15b130ba7c1b6392f57a78ca'
AND (
token = 'xw6v+vSvpOQdZgbBukfhmVWHUWb1ie9mHdv1w1RoJYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)