UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RLTTer5ODUWTnbLI/CankvFYNLBXYh4z2PzwBBsFxNM=' 
WHERE 
  key_id = '2fc23257c1324b1e44af7f68c96537bf858f813a03ecb5ca4e8036477cbf6d00' 
  AND (
    token = 'RLTTer5ODUWTnbLI/CankvFYNLBXYh4z2PzwBBsFxNM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046