UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK4jSnmK6NlOVi+RiBXmbWI+MMwoyirsnGkuiVr1O50='
WHERE
key_id = '0831585d32c222952866b857ecbcf76c04c7ed8779a9dc4459df7677635a990e'
AND (
token = 'zK4jSnmK6NlOVi+RiBXmbWI+MMwoyirsnGkuiVr1O50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)