UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjwHN/aTKYE5nup/I4nOzWSKhtDRP5CES9nwoMDSyvY='
WHERE
key_id = 'ecb9c29eb3925cd27fd57efccb93b6eb9db71eab8da9023f2d3bb1a7b7e30008'
AND (
token = 'mjwHN/aTKYE5nup/I4nOzWSKhtDRP5CES9nwoMDSyvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)