UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '17cR8/+32OiQbKjQFRXzJv7M52Nb1ooi7u/mhWy1oXc=' 
WHERE 
  key_id = 'a498de8a6e5eea79a5e5e2311c3ae0ee91b7f56c7f57d1ea2bc0534ff91a6527' 
  AND (
    token = '17cR8/+32OiQbKjQFRXzJv7M52Nb1ooi7u/mhWy1oXc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032