UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WxJ3kRQu8EswjnGNL25QqFc3ioxM9ulibd/obzwCjyw=' 
WHERE 
  key_id = 'c8fd3f03c2f1674e1ef549d3374c78f0af7b1c0e91a3c643bba7da5d7595953e' 
  AND (
    token = 'WxJ3kRQu8EswjnGNL25QqFc3ioxM9ulibd/obzwCjyw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052