UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Bj4CLV1mPv9G/d7b/vWVXmQ6/MbxOXuUXgNYq+GMSjs=' 
WHERE 
  key_id = '4728d144b8b72cdd80b7ca83d1d8b4ce7b28f891d4012b7db729dd6ca07dbdd1' 
  AND (
    token = 'Bj4CLV1mPv9G/d7b/vWVXmQ6/MbxOXuUXgNYq+GMSjs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022